Pandas Profiling Report

Dataset statistics

Number of variables	33
Number of observations	59695
Missing cells	236
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	15.0 MiB
Average record size in memory	264.0 B

Variable types

Numeric	13
Categorical	20

Warnings

`Country` has a high cardinality: 155 distinct values	High cardinality
`Agent` has a high cardinality: 296 distinct values	High cardinality
`Company` has a high cardinality: 287 distinct values	High cardinality
`ReservationStatusDate` has a high cardinality: 902 distinct values	High cardinality
`IsCanceled` is highly correlated with `ReservationStatus`	High correlation
`ReservationStatus` is highly correlated with `IsCanceled`	High correlation
`Adults` is highly skewed (γ1 = 20.93767433)	Skewed
`PreviousCancellations` is highly skewed (γ1 = 23.97962684)	Skewed
`PreviousBookingsNotCanceled` is highly skewed (γ1 = 23.41816044)	Skewed
`df_index` has unique values	Unique
`LeadTime` has 3194 (5.4%) zeros	Zeros
`StaysInWeekendNights` has 25912 (43.4%) zeros	Zeros
`StaysInWeekNights` has 3814 (6.4%) zeros	Zeros
`PreviousCancellations` has 56480 (94.6%) zeros	Zeros
`PreviousBookingsNotCanceled` has 57855 (96.9%) zeros	Zeros
`BookingChanges` has 50647 (84.8%) zeros	Zeros
`DaysInWaitingList` has 57831 (96.9%) zeros	Zeros
`ADR` has 967 (1.6%) zeros	Zeros
`TotalOfSpecialRequests` has 35108 (58.8%) zeros	Zeros

Reproduction

Analysis started	2021-01-30 01:23:57.063961
Analysis finished	2021-01-30 01:24:50.555673
Duration	53.49 seconds
Software version	pandas-profiling v2.10.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	59695
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	59674.85957
Minimum	2
Maximum	119387
Zeros	0
Zeros (%)	0.0%
Memory size	466.5 KiB

Quantile statistics

Minimum	2
5-th percentile	5987.7
Q1	29892.5
median	59526
Q3	89425
95-th percentile	113205.3
Maximum	119387
Range	119385
Interquartile range (IQR)	59532.5

Descriptive statistics

Standard deviation	34386.1497
Coefficient of variation (CV)	0.5762250627
Kurtosis	-1.198923187
Mean	59674.85957
Median Absolute Deviation (MAD)	29772
Skewness	0.00104454835
Sum	3562290742
Variance	1182407291
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12282	1	< 0.1%
60168	1	< 0.1%
19228	1	< 0.1%
25369	1	< 0.1%
27416	1	< 0.1%
6934	1	< 0.1%
2836	1	< 0.1%
13075	1	< 0.1%
15122	1	< 0.1%
11024	1	< 0.1%
Other values (59685)	59685	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	< 0.1%
3	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%

Value	Count	Frequency (%)
119387	1	< 0.1%
119386	1	< 0.1%
119383	1	< 0.1%
119382	1	< 0.1%
119381	1	< 0.1%

IsCanceled
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

0	37738
1	21957

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	59695
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	1

Value	Count	Frequency (%)
0	37738	63.2%
1	21957	36.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	37738	63.2%
1	21957	36.8%

Most occurring characters

Value	Count	Frequency (%)
0	37738	63.2%
1	21957	36.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	59695	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	37738	63.2%
1	21957	36.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	59695	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	37738	63.2%
1	21957	36.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	59695	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	37738	63.2%
1	21957	36.8%

LeadTime
Real number (ℝ_≥0)

ZEROS

Distinct	472
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	103.5098249
Minimum	0
Maximum	629
Zeros	3194
Zeros (%)	5.4%
Memory size	466.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	18
median	69
Q3	159
95-th percentile	319
Maximum	629
Range	629
Interquartile range (IQR)	141

Descriptive statistics

Standard deviation	106.7560362
Coefficient of variation (CV)	1.031361383
Kurtosis	1.727359234
Mean	103.5098249
Median Absolute Deviation (MAD)	60
Skewness	1.357370779
Sum	6179019
Variance	11396.85127
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3194	5.4%
1	1766	3.0%
2	1024	1.7%
3	922	1.5%
4	838	1.4%
5	776	1.3%
6	728	1.2%
7	643	1.1%
8	583	1.0%
12	558	0.9%
Other values (462)	48663	81.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3194	5.4%
1	1766	3.0%
2	1024	1.7%
3	922	1.5%
4	838	1.4%

Value	Count	Frequency (%)
629	10	< 0.1%
626	14	< 0.1%
622	9	< 0.1%
615	9	< 0.1%
608	6	< 0.1%

ArrivalDateYear
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

2016	28375
2017	20274
2015	11046

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	238780
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2015
2nd row	2017
3rd row	2016
4th row	2016
5th row	2016

Value	Count	Frequency (%)
2016	28375	47.5%
2017	20274	34.0%
2015	11046	18.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
2016	28375	47.5%
2017	20274	34.0%
2015	11046	18.5%

Most occurring characters

Value	Count	Frequency (%)
2	59695	25.0%
0	59695	25.0%
1	59695	25.0%
6	28375	11.9%
7	20274	8.5%
5	11046	4.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	238780	100.0%

Most frequent character per category

Value	Count	Frequency (%)
2	59695	25.0%
0	59695	25.0%
1	59695	25.0%
6	28375	11.9%
7	20274	8.5%
5	11046	4.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	238780	100.0%

Most frequent character per script

Value	Count	Frequency (%)
2	59695	25.0%
0	59695	25.0%
1	59695	25.0%
6	28375	11.9%
7	20274	8.5%
5	11046	4.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	238780	100.0%

Most frequent character per block

Value	Count	Frequency (%)
2	59695	25.0%
0	59695	25.0%
1	59695	25.0%
6	28375	11.9%
7	20274	8.5%
5	11046	4.6%

ArrivalDateMonth
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

August	6916
July	6302
May	5931
October	5589
April	5535
Other values (7)	29422

Length

Max length	9
Median length	6
Mean length	5.904028813
Min length	3

Characters and Unicode

Total characters	352441
Distinct characters	26
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	July
2nd row	April
3rd row	February
4th row	October
5th row	July

Value	Count	Frequency (%)
August	6916	11.6%
July	6302	10.6%
May	5931	9.9%
October	5589	9.4%
April	5535	9.3%
June	5448	9.1%
September	5238	8.8%
March	4908	8.2%
February	4099	6.9%
December	3419	5.7%
Other values (2)	6310	10.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
august	6916	11.6%
july	6302	10.6%
may	5931	9.9%
october	5589	9.4%
april	5535	9.3%
june	5448	9.1%
september	5238	8.8%
march	4908	8.2%
february	4099	6.9%
december	3419	5.7%
Other values (2)	6310	10.6%

Most occurring characters

Value	Count	Frequency (%)
e	47823	13.6%
r	39197	11.1%
u	32633	9.3%
b	21703	6.2%
a	20842	5.9%
y	19284	5.5%
t	17743	5.0%
J	14702	4.2%
c	13916	3.9%
A	12451	3.5%
Other values (16)	112147	31.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	292746	83.1%
Uppercase Letter	59695	16.9%

Most frequent character per category

Value	Count	Frequency (%)
e	47823	16.3%
r	39197	13.4%
u	32633	11.1%
b	21703	7.4%
a	20842	7.1%
y	19284	6.6%
t	17743	6.1%
c	13916	4.8%
m	12015	4.1%
l	11837	4.0%
Other values (8)	55753	19.0%

Value	Count	Frequency (%)
J	14702	24.6%
A	12451	20.9%
M	10839	18.2%
O	5589	9.4%
S	5238	8.8%
F	4099	6.9%
D	3419	5.7%
N	3358	5.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	352441	100.0%

Most frequent character per script

Value	Count	Frequency (%)
e	47823	13.6%
r	39197	11.1%
u	32633	9.3%
b	21703	6.2%
a	20842	5.9%
y	19284	5.5%
t	17743	5.0%
J	14702	4.2%
c	13916	3.9%
A	12451	3.5%
Other values (16)	112147	31.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	352441	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	47823	13.6%
r	39197	11.1%
u	32633	9.3%
b	21703	6.2%
a	20842	5.9%
y	19284	5.5%
t	17743	5.0%
J	14702	4.2%
c	13916	3.9%
A	12451	3.5%
Other values (16)	112147	31.8%

ArrivalDateWeekNumber
Real number (ℝ_≥0)

Distinct	53
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	27.13991122
Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Memory size	466.5 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	16
median	28
Q3	38
95-th percentile	49
Maximum	53
Range	52
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	13.62353557
Coefficient of variation (CV)	0.5019742128
Kurtosis	-0.9895419997
Mean	27.13991122
Median Absolute Deviation (MAD)	11
Skewness	-0.005445386918
Sum	1620117
Variance	185.6007214
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	1791	3.0%
32	1517	2.5%
30	1513	2.5%
18	1483	2.5%
21	1471	2.5%
34	1462	2.4%
28	1417	2.4%
29	1415	2.4%
17	1412	2.4%
31	1408	2.4%
Other values (43)	44806	75.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	524	0.9%
2	618	1.0%
3	656	1.1%
4	733	1.2%
5	694	1.2%

Value	Count	Frequency (%)
53	933	1.6%
52	589	1.0%
51	476	0.8%
50	728	1.2%
49	930	1.6%

ArrivalDateDayOfMonth
Real number (ℝ_≥0)

Distinct	31
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	15.79656588
Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Memory size	466.5 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.782652219
Coefficient of variation (CV)	0.5559849076
Kurtosis	-1.186781255
Mean	15.79656588
Median Absolute Deviation (MAD)	8
Skewness	0.0003471236631
Sum	942976
Variance	77.13498
Monotocity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
17	2257	3.8%
5	2196	3.7%
15	2106	3.5%
9	2065	3.5%
26	2054	3.4%
25	2048	3.4%
2	2039	3.4%
12	2028	3.4%
16	2013	3.4%
18	2006	3.4%
Other values (21)	38883	65.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1786	3.0%
2	2039	3.4%
3	1944	3.3%
4	1856	3.1%
5	2196	3.7%

Value	Count	Frequency (%)
31	1105	1.9%
30	1972	3.3%
29	1775	3.0%
28	1951	3.3%
27	1939	3.2%

StaysInWeekendNights
Real number (ℝ_≥0)

ZEROS

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.9307144652
Minimum	0
Maximum	16
Zeros	25912
Zeros (%)	43.4%
Memory size	466.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	2
Maximum	16
Range	16
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.9994422929
Coefficient of variation (CV)	1.07384416
Kurtosis	5.610020657
Mean	0.9307144652
Median Absolute Deviation (MAD)	1
Skewness	1.315806974
Sum	55559
Variance	0.9988848968
Monotocity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
0	25912	43.4%
2	16676	27.9%
1	15352	25.7%
4	918	1.5%
3	651	1.1%
6	81	0.1%
5	46	0.1%
8	33	0.1%
7	8	< 0.1%
9	7	< 0.1%
Other values (5)	11	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	25912	43.4%
1	15352	25.7%
2	16676	27.9%
3	651	1.1%
4	918	1.5%

Value	Count	Frequency (%)
16	1	< 0.1%
14	1	< 0.1%
13	1	< 0.1%
12	4	< 0.1%
10	4	< 0.1%

StaysInWeekNights
Real number (ℝ_≥0)

ZEROS

Distinct	30
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.502119105
Minimum	0
Maximum	41
Zeros	3814
Zeros (%)	6.4%
Memory size	466.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	3
95-th percentile	5
Maximum	41
Range	41
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.909964042
Coefficient of variation (CV)	0.7633385788
Kurtosis	19.67455136
Mean	2.502119105
Median Absolute Deviation (MAD)	1
Skewness	2.719199321
Sum	149364
Variance	3.647962642
Monotocity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
2	16856	28.2%
1	15189	25.4%
3	11012	18.4%
5	5531	9.3%
4	4848	8.1%
0	3814	6.4%
6	750	1.3%
7	532	0.9%
10	495	0.8%
8	334	0.6%
Other values (20)	334	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3814	6.4%
1	15189	25.4%
2	16856	28.2%
3	11012	18.4%
4	4848	8.1%

Value	Count	Frequency (%)
41	1	< 0.1%
35	1	< 0.1%
32	1	< 0.1%
30	3	< 0.1%
26	1	< 0.1%

Adults
Real number (ℝ_≥0)

SKEWED

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.859452215
Minimum	0
Maximum	55
Zeros	217
Zeros (%)	0.4%
Memory size	466.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	3
Maximum	55
Range	55
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.597186927
Coefficient of variation (CV)	0.3211628253
Kurtosis	1529.296426
Mean	1.859452215
Median Absolute Deviation (MAD)	0
Skewness	20.93767433
Sum	111000
Variance	0.3566322258
Monotocity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
2	44911	75.2%
1	11378	19.1%
3	3151	5.3%
0	217	0.4%
4	29	< 0.1%
26	3	< 0.1%
27	1	< 0.1%
55	1	< 0.1%
20	1	< 0.1%
40	1	< 0.1%
Other values (2)	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	217	0.4%
1	11378	19.1%
2	44911	75.2%
3	3151	5.3%
4	29	< 0.1%

Value	Count	Frequency (%)
55	1	< 0.1%
40	1	< 0.1%
27	1	< 0.1%
26	3	< 0.1%
20	1	< 0.1%

Children
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

0.0	55346
1.0	2422
2.0	1893
3.0	30
nan	4

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	179085
Distinct characters	7
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	2.0

Value	Count	Frequency (%)
0.0	55346	92.7%
1.0	2422	4.1%
2.0	1893	3.2%
3.0	30	0.1%
nan	4	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0.0	55346	92.7%
1.0	2422	4.1%
2.0	1893	3.2%
3.0	30	0.1%
nan	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	115037	64.2%
.	59691	33.3%
1	2422	1.4%
2	1893	1.1%
3	30	< 0.1%
n	8	< 0.1%
a	4	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	119382	66.7%
Other Punctuation	59691	33.3%
Lowercase Letter	12	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
0	115037	96.4%
1	2422	2.0%
2	1893	1.6%
3	30	< 0.1%

Value	Count	Frequency (%)
n	8	66.7%
a	4	33.3%

Value	Count	Frequency (%)
.	59691	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	179073	> 99.9%
Latin	12	< 0.1%

Most frequent character per script

Value	Count	Frequency (%)
0	115037	64.2%
.	59691	33.3%
1	2422	1.4%
2	1893	1.1%
3	30	< 0.1%

Value	Count	Frequency (%)
n	8	66.7%
a	4	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	179085	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	115037	64.2%
.	59691	33.3%
1	2422	1.4%
2	1893	1.1%
3	30	< 0.1%
n	8	< 0.1%
a	4	< 0.1%

Babies
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

0	59229
1	458
2	8

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	59695
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	59229	99.2%
1	458	0.8%
2	8	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	59229	99.2%
1	458	0.8%
2	8	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	59229	99.2%
1	458	0.8%
2	8	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	59695	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	59229	99.2%
1	458	0.8%
2	8	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	59695	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	59229	99.2%
1	458	0.8%
2	8	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	59695	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	59229	99.2%
1	458	0.8%
2	8	< 0.1%

Meal
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

BB	46118
HB	7262
SC	5309
Undefined	598
FB	408

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	537255
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FB
2nd row	HB
3rd row	BB
4th row	BB
5th row	BB

Value	Count	Frequency (%)
BB	46118	77.3%
HB	7262	12.2%
SC	5309	8.9%
Undefined	598	1.0%
FB	408	0.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
bb	46118	77.3%
hb	7262	12.2%
sc	5309	8.9%
undefined	598	1.0%
fb	408	0.7%

Most occurring characters

Value	Count	Frequency (%)
	413679	77.0%
B	99906	18.6%
H	7262	1.4%
S	5309	1.0%
C	5309	1.0%
n	1196	0.2%
d	1196	0.2%
e	1196	0.2%
U	598	0.1%
f	598	0.1%
Other values (2)	1006	0.2%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	413679	77.0%
Uppercase Letter	118792	22.1%
Lowercase Letter	4784	0.9%

Most frequent character per category

Value	Count	Frequency (%)
B	99906	84.1%
H	7262	6.1%
S	5309	4.5%
C	5309	4.5%
U	598	0.5%
F	408	0.3%

Value	Count	Frequency (%)
n	1196	25.0%
d	1196	25.0%
e	1196	25.0%
f	598	12.5%
i	598	12.5%

Value	Count	Frequency (%)
	413679	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	413679	77.0%
Latin	123576	23.0%

Most frequent character per script

Value	Count	Frequency (%)
B	99906	80.8%
H	7262	5.9%
S	5309	4.3%
C	5309	4.3%
n	1196	1.0%
d	1196	1.0%
e	1196	1.0%
U	598	0.5%
f	598	0.5%
i	598	0.5%

Value	Count	Frequency (%)
	413679	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	537255	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	413679	77.0%
B	99906	18.6%
H	7262	1.4%
S	5309	1.0%
C	5309	1.0%
n	1196	0.2%
d	1196	0.2%
e	1196	0.2%
U	598	0.1%
f	598	0.1%
Other values (2)	1006	0.2%

Country
Categorical

HIGH CARDINALITY

Distinct	155
Distinct (%)	0.3%
Missing	236
Missing (%)	0.4%
Memory size	466.5 KiB

PRT	24171
GBR	6125
FRA	5217
ESP	4275
DEU	3600
Other values (150)	16071

Length

Max length	3
Median length	3
Mean length	2.989370827
Min length	2

Characters and Unicode

Total characters	177745
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	27 ?
Unique (%)	< 0.1%

Sample

1st row	PRT
2nd row	PRT
3rd row	GBR
4th row	PRT
5th row	GBR

Value	Count	Frequency (%)
PRT	24171	40.5%
GBR	6125	10.3%
FRA	5217	8.7%
ESP	4275	7.2%
DEU	3600	6.0%
ITA	1856	3.1%
IRL	1665	2.8%
BEL	1243	2.1%
BRA	1135	1.9%
NLD	1065	1.8%
Other values (145)	9107	15.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
prt	24171	40.7%
gbr	6125	10.3%
fra	5217	8.8%
esp	4275	7.2%
deu	3600	6.1%
ita	1856	3.1%
irl	1665	2.8%
bel	1243	2.1%
bra	1135	1.9%
nld	1065	1.8%
Other values (145)	9107	15.3%

Most occurring characters

Value	Count	Frequency (%)
R	40360	22.7%
P	29139	16.4%
T	26982	15.2%
A	10838	6.1%
E	10806	6.1%
B	8672	4.9%
S	6966	3.9%
G	6651	3.7%
U	6599	3.7%
F	5484	3.1%
Other values (16)	25248	14.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	177745	100.0%

Most frequent character per category

Value	Count	Frequency (%)
R	40360	22.7%
P	29139	16.4%
T	26982	15.2%
A	10838	6.1%
E	10806	6.1%
B	8672	4.9%
S	6966	3.9%
G	6651	3.7%
U	6599	3.7%
F	5484	3.1%
Other values (16)	25248	14.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	177745	100.0%

Most frequent character per script

Value	Count	Frequency (%)
R	40360	22.7%
P	29139	16.4%
T	26982	15.2%
A	10838	6.1%
E	10806	6.1%
B	8672	4.9%
S	6966	3.9%
G	6651	3.7%
U	6599	3.7%
F	5484	3.1%
Other values (16)	25248	14.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	177745	100.0%

Most frequent character per block

Value	Count	Frequency (%)
R	40360	22.7%
P	29139	16.4%
T	26982	15.2%
A	10838	6.1%
E	10806	6.1%
B	8672	4.9%
S	6966	3.9%
G	6651	3.7%
U	6599	3.7%
F	5484	3.1%
Other values (16)	25248	14.2%

MarketSegment
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

Online TA	28322
Offline TA/TO	12084
Groups	9826
Direct	6323
Corporate	2656
Other values (3)	484

Length

Max length	13
Median length	9
Mean length	9.021224558
Min length	6

Characters and Unicode

Total characters	538522
Distinct characters	26
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Groups
2nd row	Groups
3rd row	Offline TA/TO
4th row	Online TA
5th row	Online TA

Value	Count	Frequency (%)
Online TA	28322	47.4%
Offline TA/TO	12084	20.2%
Groups	9826	16.5%
Direct	6323	10.6%
Corporate	2656	4.4%
Complementary	372	0.6%
Aviation	110	0.2%
Undefined	2	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
online	28322	28.3%
ta	28322	28.3%
ta/to	12084	12.1%
offline	12084	12.1%
groups	9826	9.8%
direct	6323	6.3%
corporate	2656	2.7%
complementary	372	0.4%
aviation	110	0.1%
undefined	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
n	69214	12.9%
O	52490	9.7%
T	52490	9.7%
e	50133	9.3%
i	46951	8.7%
l	40778	7.6%
A	40516	7.5%
	40406	7.5%
f	24170	4.5%
r	21833	4.1%
Other values (16)	99541	18.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	321357	59.7%
Uppercase Letter	164675	30.6%
Space Separator	40406	7.5%
Other Punctuation	12084	2.2%

Most frequent character per category

Value	Count	Frequency (%)
n	69214	21.5%
e	50133	15.6%
i	46951	14.6%
l	40778	12.7%
f	24170	7.5%
r	21833	6.8%
o	15620	4.9%
p	12854	4.0%
u	9826	3.1%
s	9826	3.1%
Other values (7)	20152	6.3%

Value	Count	Frequency (%)
O	52490	31.9%
T	52490	31.9%
A	40516	24.6%
G	9826	6.0%
D	6323	3.8%
C	3028	1.8%
U	2	< 0.1%

Value	Count	Frequency (%)
	40406	100.0%

Value	Count	Frequency (%)
/	12084	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	486032	90.3%
Common	52490	9.7%

Most frequent character per script

Value	Count	Frequency (%)
n	69214	14.2%
O	52490	10.8%
T	52490	10.8%
e	50133	10.3%
i	46951	9.7%
l	40778	8.4%
A	40516	8.3%
f	24170	5.0%
r	21833	4.5%
o	15620	3.2%
Other values (14)	71837	14.8%

Value	Count	Frequency (%)
	40406	77.0%
/	12084	23.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	538522	100.0%

Most frequent character per block

Value	Count	Frequency (%)
n	69214	12.9%
O	52490	9.7%
T	52490	9.7%
e	50133	9.3%
i	46951	8.7%
l	40778	7.6%
A	40516	7.5%
	40406	7.5%
f	24170	4.5%
r	21833	4.1%
Other values (16)	99541	18.5%

DistributionChannel
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

TA/TO	48916
Direct	7344
Corporate	3341
GDS	89
Undefined	5

Length

Max length	9
Median length	5
Mean length	5.344249937
Min length	3

Characters and Unicode

Total characters	319025
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Direct
2nd row	TA/TO
3rd row	TA/TO
4th row	TA/TO
5th row	TA/TO

Value	Count	Frequency (%)
TA/TO	48916	81.9%
Direct	7344	12.3%
Corporate	3341	5.6%
GDS	89	0.1%
Undefined	5	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
ta/to	48916	81.9%
direct	7344	12.3%
corporate	3341	5.6%
gds	89	0.1%
undefined	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
T	97832	30.7%
A	48916	15.3%
/	48916	15.3%
O	48916	15.3%
r	14026	4.4%
e	10695	3.4%
t	10685	3.3%
D	7433	2.3%
i	7349	2.3%
c	7344	2.3%
Other values (10)	16913	5.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	206621	64.8%
Lowercase Letter	63488	19.9%
Other Punctuation	48916	15.3%

Most frequent character per category

Value	Count	Frequency (%)
r	14026	22.1%
e	10695	16.8%
t	10685	16.8%
i	7349	11.6%
c	7344	11.6%
o	6682	10.5%
p	3341	5.3%
a	3341	5.3%
n	10	< 0.1%
d	10	< 0.1%

Value	Count	Frequency (%)
T	97832	47.3%
A	48916	23.7%
O	48916	23.7%
D	7433	3.6%
C	3341	1.6%
G	89	< 0.1%
S	89	< 0.1%
U	5	< 0.1%

Value	Count	Frequency (%)
/	48916	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	270109	84.7%
Common	48916	15.3%

Most frequent character per script

Value	Count	Frequency (%)
T	97832	36.2%
A	48916	18.1%
O	48916	18.1%
r	14026	5.2%
e	10695	4.0%
t	10685	4.0%
D	7433	2.8%
i	7349	2.7%
c	7344	2.7%
o	6682	2.5%
Other values (9)	10231	3.8%

Value	Count	Frequency (%)
/	48916	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	319025	100.0%

Most frequent character per block

Value	Count	Frequency (%)
T	97832	30.7%
A	48916	15.3%
/	48916	15.3%
O	48916	15.3%
r	14026	4.4%
e	10695	3.4%
t	10685	3.3%
D	7433	2.3%
i	7349	2.3%
c	7344	2.3%
Other values (10)	16913	5.3%

IsRepeatedGuest
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

0	57737
1	1958

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	59695
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	1
5th row	0

Value	Count	Frequency (%)
0	57737	96.7%
1	1958	3.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	57737	96.7%
1	1958	3.3%

Most occurring characters

Value	Count	Frequency (%)
0	57737	96.7%
1	1958	3.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	59695	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	57737	96.7%
1	1958	3.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	59695	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	57737	96.7%
1	1958	3.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	59695	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	57737	96.7%
1	1958	3.3%

PreviousCancellations
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.088064327
Minimum	0
Maximum	26
Zeros	56480
Zeros (%)	94.6%
Memory size	466.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	26
Range	26
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.8557465581
Coefficient of variation (CV)	9.717289477
Kurtosis	649.0697173
Mean	0.088064327
Median Absolute Deviation (MAD)	0
Skewness	23.97962684
Sum	5257
Variance	0.7323021716
Monotocity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0	56480	94.6%
1	2987	5.0%
2	65	0.1%
3	31	0.1%
11	21	< 0.1%
24	20	< 0.1%
25	16	< 0.1%
5	14	< 0.1%
26	13	< 0.1%
19	12	< 0.1%
Other values (4)	36	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	56480	94.6%
1	2987	5.0%
2	65	0.1%
3	31	0.1%
4	10	< 0.1%

Value	Count	Frequency (%)
26	13	< 0.1%
25	16	< 0.1%
24	20	< 0.1%
19	12	< 0.1%
14	6	< 0.1%

PreviousBookingsNotCanceled
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	55
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.136745121
Minimum	0
Maximum	70
Zeros	57855
Zeros (%)	96.9%
Memory size	466.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	70
Range	70
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.487479995
Coefficient of variation (CV)	10.87775552
Kurtosis	751.5324858
Mean	0.136745121
Median Absolute Deviation (MAD)	0
Skewness	23.41816044
Sum	8163
Variance	2.212596736
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	57855	96.9%
1	803	1.3%
2	299	0.5%
3	155	0.3%
4	115	0.2%
5	95	0.2%
6	54	0.1%
7	43	0.1%
8	35	0.1%
9	30	0.1%
Other values (45)	211	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	57855	96.9%
1	803	1.3%
2	299	0.5%
3	155	0.3%
4	115	0.2%

Value	Count	Frequency (%)
70	1	< 0.1%
68	1	< 0.1%
64	1	< 0.1%
63	1	< 0.1%
61	1	< 0.1%

ReservedRoomType
Categorical

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

A	42831
D	9679
E	3257
F	1479
G	1053
Other values (5)	1396

Length

Max length	16
Median length	16
Mean length	16
Min length	16

Characters and Unicode

Total characters	955120
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A
2nd row	A
3rd row	A
4th row	A
5th row	B

Value	Count	Frequency (%)
A	42831	71.7%
D	9679	16.2%
E	3257	5.5%
F	1479	2.5%
G	1053	1.8%
B	608	1.0%
C	473	0.8%
H	307	0.5%
L	5	< 0.1%
P	3	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
a	42831	71.7%
d	9679	16.2%
e	3257	5.5%
f	1479	2.5%
g	1053	1.8%
b	608	1.0%
c	473	0.8%
h	307	0.5%
l	5	< 0.1%
p	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
	895425	93.8%
A	42831	4.5%
D	9679	1.0%
E	3257	0.3%
F	1479	0.2%
G	1053	0.1%
B	608	0.1%
C	473	< 0.1%
H	307	< 0.1%
L	5	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	895425	93.8%
Uppercase Letter	59695	6.2%

Most frequent character per category

Value	Count	Frequency (%)
A	42831	71.7%
D	9679	16.2%
E	3257	5.5%
F	1479	2.5%
G	1053	1.8%
B	608	1.0%
C	473	0.8%
H	307	0.5%
L	5	< 0.1%
P	3	< 0.1%

Value	Count	Frequency (%)
	895425	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	895425	93.8%
Latin	59695	6.2%

Most frequent character per script

Value	Count	Frequency (%)
A	42831	71.7%
D	9679	16.2%
E	3257	5.5%
F	1479	2.5%
G	1053	1.8%
B	608	1.0%
C	473	0.8%
H	307	0.5%
L	5	< 0.1%
P	3	< 0.1%

Value	Count	Frequency (%)
	895425	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	955120	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	895425	93.8%
A	42831	4.5%
D	9679	1.0%
E	3257	0.3%
F	1479	0.2%
G	1053	0.1%
B	608	0.1%
C	473	< 0.1%
H	307	< 0.1%
L	5	< 0.1%

AssignedRoomType
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

A	36878
D	12736
E	3880
F	1948
G	1280
Other values (7)	2973

Length

Max length	16
Median length	16
Mean length	16
Min length	16

Characters and Unicode

Total characters	955120
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	A
2nd row	A
3rd row	D
4th row	A
5th row	B

Value	Count	Frequency (%)
A	36878	61.8%
D	12736	21.3%
E	3880	6.5%
F	1948	3.3%
G	1280	2.1%
C	1207	2.0%
B	1081	1.8%
H	371	0.6%
I	167	0.3%
K	143	0.2%
Other values (2)	4	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
a	36878	61.8%
d	12736	21.3%
e	3880	6.5%
f	1948	3.3%
g	1280	2.1%
c	1207	2.0%
b	1081	1.8%
h	371	0.6%
i	167	0.3%
k	143	0.2%
Other values (2)	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
	895425	93.8%
A	36878	3.9%
D	12736	1.3%
E	3880	0.4%
F	1948	0.2%
G	1280	0.1%
C	1207	0.1%
B	1081	0.1%
H	371	< 0.1%
I	167	< 0.1%
Other values (3)	147	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	895425	93.8%
Uppercase Letter	59695	6.2%

Most frequent character per category

Value	Count	Frequency (%)
A	36878	61.8%
D	12736	21.3%
E	3880	6.5%
F	1948	3.3%
G	1280	2.1%
C	1207	2.0%
B	1081	1.8%
H	371	0.6%
I	167	0.3%
K	143	0.2%
Other values (2)	4	< 0.1%

Value	Count	Frequency (%)
	895425	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	895425	93.8%
Latin	59695	6.2%

Most frequent character per script

Value	Count	Frequency (%)
A	36878	61.8%
D	12736	21.3%
E	3880	6.5%
F	1948	3.3%
G	1280	2.1%
C	1207	2.0%
B	1081	1.8%
H	371	0.6%
I	167	0.3%
K	143	0.2%
Other values (2)	4	< 0.1%

Value	Count	Frequency (%)
	895425	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	955120	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	895425	93.8%
A	36878	3.9%
D	12736	1.3%
E	3880	0.4%
F	1948	0.2%
G	1280	0.1%
C	1207	0.1%
B	1081	0.1%
H	371	< 0.1%
I	167	< 0.1%
Other values (3)	147	< 0.1%

BookingChanges
Real number (ℝ_≥0)

ZEROS

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.2225982076
Minimum	0
Maximum	21
Zeros	50647
Zeros (%)	84.8%
Memory size	466.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	21
Range	21
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6667099906
Coefficient of variation (CV)	2.9951274
Kurtosis	95.18461672
Mean	0.2225982076
Median Absolute Deviation (MAD)	0
Skewness	6.561586101
Sum	13288
Variance	0.4445022116
Monotocity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
0	50647	84.8%
1	6345	10.6%
2	1924	3.2%
3	453	0.8%
4	185	0.3%
5	52	0.1%
6	41	0.1%
7	15	< 0.1%
8	9	< 0.1%
10	5	< 0.1%
Other values (10)	19	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	50647	84.8%
1	6345	10.6%
2	1924	3.2%
3	453	0.8%
4	185	0.3%

Value	Count	Frequency (%)
21	1	< 0.1%
20	1	< 0.1%
18	1	< 0.1%
16	1	< 0.1%
15	2	< 0.1%

DepositType
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

No Deposit	52453
Non Refund	7157
Refundable	85

Length

Max length	15
Median length	15
Mean length	15
Min length	15

Characters and Unicode

Total characters	895425
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Deposit
2nd row	No Deposit
3rd row	No Deposit
4th row	No Deposit
5th row	No Deposit

Value	Count	Frequency (%)
No Deposit	52453	87.9%
Non Refund	7157	12.0%
Refundable	85	0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
no	52453	44.0%
deposit	52453	44.0%
refund	7157	6.0%
non	7157	6.0%
refundable	85	0.1%

Most occurring characters

Value	Count	Frequency (%)
	358085	40.0%
o	112063	12.5%
e	59780	6.7%
N	59610	6.7%
D	52453	5.9%
p	52453	5.9%
s	52453	5.9%
i	52453	5.9%
t	52453	5.9%
n	14399	1.6%
Other values (7)	29223	3.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	418035	46.7%
Space Separator	358085	40.0%
Uppercase Letter	119305	13.3%

Most frequent character per category

Value	Count	Frequency (%)
o	112063	26.8%
e	59780	14.3%
p	52453	12.5%
s	52453	12.5%
i	52453	12.5%
t	52453	12.5%
n	14399	3.4%
f	7242	1.7%
u	7242	1.7%
d	7242	1.7%
Other values (3)	255	0.1%

Value	Count	Frequency (%)
N	59610	50.0%
D	52453	44.0%
R	7242	6.1%

Value	Count	Frequency (%)
	358085	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	537340	60.0%
Common	358085	40.0%

Most frequent character per script

Value	Count	Frequency (%)
o	112063	20.9%
e	59780	11.1%
N	59610	11.1%
D	52453	9.8%
p	52453	9.8%
s	52453	9.8%
i	52453	9.8%
t	52453	9.8%
n	14399	2.7%
R	7242	1.3%
Other values (6)	21981	4.1%

Value	Count	Frequency (%)
	358085	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	895425	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	358085	40.0%
o	112063	12.5%
e	59780	6.7%
N	59610	6.7%
D	52453	5.9%
p	52453	5.9%
s	52453	5.9%
i	52453	5.9%
t	52453	5.9%
n	14399	1.6%
Other values (7)	29223	3.3%

Agent
Categorical

HIGH CARDINALITY

Distinct	296
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

9	16128
NULL	8161
240	6923
1	3585
14	1810
Other values (291)	23088

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	656645
Distinct characters	14
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	41 ?
Unique (%)	0.1%

Sample

1st row	305
2nd row	NULL
3rd row	6
4th row	240
5th row	9

Value	Count	Frequency (%)
9	16128	27.0%
NULL	8161	13.7%
240	6923	11.6%
1	3585	6.0%
14	1810	3.0%
7	1766	3.0%
6	1653	2.8%
250	1398	2.3%
241	844	1.4%
28	797	1.3%
Other values (286)	16630	27.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
9	16128	27.0%
null	8161	13.7%
240	6923	11.6%
1	3585	6.0%
14	1810	3.0%
7	1766	3.0%
6	1653	2.8%
250	1398	2.3%
241	844	1.4%
28	797	1.3%
Other values (286)	16630	27.9%

Most occurring characters

Value	Count	Frequency (%)
	529522	80.6%
9	19250	2.9%
2	16337	2.5%
L	16322	2.5%
4	13514	2.1%
1	13360	2.0%
0	10141	1.5%
N	8161	1.2%
U	8161	1.2%
3	5429	0.8%
Other values (4)	16448	2.5%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	529522	80.6%
Decimal Number	94479	14.4%
Uppercase Letter	32644	5.0%

Most frequent character per category

Value	Count	Frequency (%)
9	19250	20.4%
2	16337	17.3%
4	13514	14.3%
1	13360	14.1%
0	10141	10.7%
3	5429	5.7%
7	4316	4.6%
5	4245	4.5%
8	4040	4.3%
6	3847	4.1%

Value	Count	Frequency (%)
L	16322	50.0%
N	8161	25.0%
U	8161	25.0%

Value	Count	Frequency (%)
	529522	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	624001	95.0%
Latin	32644	5.0%

Most frequent character per script

Value	Count	Frequency (%)
	529522	84.9%
9	19250	3.1%
2	16337	2.6%
4	13514	2.2%
1	13360	2.1%
0	10141	1.6%
3	5429	0.9%
7	4316	0.7%
5	4245	0.7%
8	4040	0.6%

Value	Count	Frequency (%)
L	16322	50.0%
N	8161	25.0%
U	8161	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	656645	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	529522	80.6%
9	19250	2.9%
2	16337	2.5%
L	16322	2.5%
4	13514	2.1%
1	13360	2.0%
0	10141	1.5%
N	8161	1.2%
U	8161	1.2%
3	5429	0.8%
Other values (4)	16448	2.5%

Company
Categorical

HIGH CARDINALITY

Distinct	287
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

NULL	56317
40	459
223	384
45	129
67	120
Other values (282)	2286

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	656645
Distinct characters	14
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	80 ?
Unique (%)	0.1%

Sample

1st row	NULL
2nd row	NULL
3rd row	NULL
4th row	NULL
5th row	NULL

Value	Count	Frequency (%)
NULL	56317	94.3%
40	459	0.8%
223	384	0.6%
45	129	0.2%
67	120	0.2%
153	107	0.2%
174	76	0.1%
281	73	0.1%
219	70	0.1%
154	65	0.1%
Other values (277)	1895	3.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
null	56317	94.3%
40	459	0.8%
223	384	0.6%
45	129	0.2%
67	120	0.2%
153	107	0.2%
174	76	0.1%
281	73	0.1%
219	70	0.1%
154	65	0.1%
Other values (277)	1895	3.2%

Most occurring characters

Value	Count	Frequency (%)
	422435	64.3%
L	112634	17.2%
N	56317	8.6%
U	56317	8.6%
2	1658	0.3%
4	1380	0.2%
3	1306	0.2%
1	1090	0.2%
0	875	0.1%
5	683	0.1%
Other values (4)	1950	0.3%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	422435	64.3%
Uppercase Letter	225268	34.3%
Decimal Number	8942	1.4%

Most frequent character per category

Value	Count	Frequency (%)
2	1658	18.5%
4	1380	15.4%
3	1306	14.6%
1	1090	12.2%
0	875	9.8%
5	683	7.6%
7	553	6.2%
8	518	5.8%
9	468	5.2%
6	411	4.6%

Value	Count	Frequency (%)
L	112634	50.0%
N	56317	25.0%
U	56317	25.0%

Value	Count	Frequency (%)
	422435	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	431377	65.7%
Latin	225268	34.3%

Most frequent character per script

Value	Count	Frequency (%)
	422435	97.9%
2	1658	0.4%
4	1380	0.3%
3	1306	0.3%
1	1090	0.3%
0	875	0.2%
5	683	0.2%
7	553	0.1%
8	518	0.1%
9	468	0.1%

Value	Count	Frequency (%)
L	112634	50.0%
N	56317	25.0%
U	56317	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	656645	100.0%

Most frequent character per block

Value	Count	Frequency (%)
	422435	64.3%
L	112634	17.2%
N	56317	8.6%
U	56317	8.6%
2	1658	0.3%
4	1380	0.2%
3	1306	0.2%
1	1090	0.2%
0	875	0.1%
5	683	0.1%
Other values (4)	1950	0.3%

DaysInWaitingList
Real number (ℝ_≥0)

ZEROS

Distinct	112
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.315319541
Minimum	0
Maximum	391
Zeros	57831
Zeros (%)	96.9%
Memory size	466.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	391
Range	391
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	17.38291424
Coefficient of variation (CV)	7.507781942
Kurtosis	181.6806056
Mean	2.315319541
Median Absolute Deviation (MAD)	0
Skewness	11.75749113
Sum	138213
Variance	302.1657074
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	57831	96.9%
39	113	0.2%
58	83	0.1%
44	73	0.1%
31	67	0.1%
35	49	0.1%
50	46	0.1%
62	42	0.1%
46	40	0.1%
38	38	0.1%
Other values (102)	1313	2.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	57831	96.9%
1	6	< 0.1%
2	3	< 0.1%
3	32	0.1%
4	14	< 0.1%

Value	Count	Frequency (%)
391	19	< 0.1%
379	8	< 0.1%
330	6	< 0.1%
259	7	< 0.1%
236	17	< 0.1%

CustomerType
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

Transient	44654
Transient-Party	12652
Contract	2064
Group	325

Length

Max length	15
Median length	9
Mean length	10.21531117
Min length	5

Characters and Unicode

Total characters	609803
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Transient-Party
2nd row	Transient-Party
3rd row	Transient
4th row	Transient-Party
5th row	Transient-Party

Value	Count	Frequency (%)
Transient	44654	74.8%
Transient-Party	12652	21.2%
Contract	2064	3.5%
Group	325	0.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
transient	44654	74.8%
transient-party	12652	21.2%
contract	2064	3.5%
group	325	0.5%

Most occurring characters

Value	Count	Frequency (%)
n	116676	19.1%
t	74086	12.1%
r	72347	11.9%
a	72022	11.8%
T	57306	9.4%
s	57306	9.4%
i	57306	9.4%
e	57306	9.4%
-	12652	2.1%
P	12652	2.1%
Other values (7)	20144	3.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	524804	86.1%
Uppercase Letter	72347	11.9%
Dash Punctuation	12652	2.1%

Most frequent character per category

Value	Count	Frequency (%)
n	116676	22.2%
t	74086	14.1%
r	72347	13.8%
a	72022	13.7%
s	57306	10.9%
i	57306	10.9%
e	57306	10.9%
y	12652	2.4%
o	2389	0.5%
c	2064	0.4%
Other values (2)	650	0.1%

Value	Count	Frequency (%)
T	57306	79.2%
P	12652	17.5%
C	2064	2.9%
G	325	0.4%

Value	Count	Frequency (%)
-	12652	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	597151	97.9%
Common	12652	2.1%

Most frequent character per script

Value	Count	Frequency (%)
n	116676	19.5%
t	74086	12.4%
r	72347	12.1%
a	72022	12.1%
T	57306	9.6%
s	57306	9.6%
i	57306	9.6%
e	57306	9.6%
P	12652	2.1%
y	12652	2.1%
Other values (6)	7492	1.3%

Value	Count	Frequency (%)
-	12652	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	609803	100.0%

Most frequent character per block

Value	Count	Frequency (%)
n	116676	19.1%
t	74086	12.1%
r	72347	11.9%
a	72022	11.8%
T	57306	9.4%
s	57306	9.4%
i	57306	9.4%
e	57306	9.4%
-	12652	2.1%
P	12652	2.1%
Other values (7)	20144	3.3%

ADR
Real number (ℝ)

ZEROS

Distinct	6269
Distinct (%)	10.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	101.8662779
Minimum	-6.38
Maximum	508
Zeros	967
Zeros (%)	1.6%
Memory size	466.5 KiB

Quantile statistics

Minimum	-6.38
5-th percentile	38.098
Q1	69.52
median	94.5
Q3	126
95-th percentile	194
Maximum	508
Range	514.38
Interquartile range (IQR)	56.48

Descriptive statistics

Standard deviation	48.13930729
Coefficient of variation (CV)	0.4725735373
Kurtosis	2.044484037
Mean	101.8662779
Median Absolute Deviation (MAD)	27.9
Skewness	1.00229947
Sum	6080907.46
Variance	2317.392906
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
62	1871	3.1%
75	1376	2.3%
90	1278	2.1%
65	1209	2.0%
0	967	1.6%
80	944	1.6%
95	803	1.3%
120	778	1.3%
100	769	1.3%
85	747	1.3%
Other values (6259)	48953	82.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-6.38	1	< 0.1%
0	967	1.6%
0.26	1	< 0.1%
1	6	< 0.1%
1.8	1	< 0.1%

Value	Count	Frequency (%)
508	1	< 0.1%
451.5	1	< 0.1%
450	1	< 0.1%
397.38	1	< 0.1%
388	2	< 0.1%

RequiredCarParkingSpaces
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

0	56022
1	3659
2	13
3	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	59695
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	56022	93.8%
1	3659	6.1%
2	13	< 0.1%
3	1	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	56022	93.8%
1	3659	6.1%
2	13	< 0.1%
3	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	56022	93.8%
1	3659	6.1%
2	13	< 0.1%
3	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	59695	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	56022	93.8%
1	3659	6.1%
2	13	< 0.1%
3	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	59695	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	56022	93.8%
1	3659	6.1%
2	13	< 0.1%
3	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	59695	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	56022	93.8%
1	3659	6.1%
2	13	< 0.1%
3	1	< 0.1%

TotalOfSpecialRequests
Real number (ℝ_≥0)

ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.5722422313
Minimum	0
Maximum	5
Zeros	35108
Zeros (%)	58.8%
Memory size	466.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7930812548
Coefficient of variation (CV)	1.38591878
Kurtosis	1.535222106
Mean	0.5722422313
Median Absolute Deviation (MAD)	0
Skewness	1.352938301
Sum	34160
Variance	0.6289778768
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	35108	58.8%
1	16665	27.9%
2	6490	10.9%
3	1237	2.1%
4	171	0.3%
5	24	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	35108	58.8%
1	16665	27.9%
2	6490	10.9%
3	1237	2.1%
4	171	0.3%

Value	Count	Frequency (%)
5	24	< 0.1%
4	171	0.3%
3	1237	2.1%
2	6490	10.9%
1	16665	27.9%

ReservationStatus
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

Check-Out	37738
Canceled	21363
No-Show	594

Length

Max length	9
Median length	9
Mean length	8.622229667
Min length	7

Characters and Unicode

Total characters	514704
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Check-Out
2nd row	Canceled
3rd row	Check-Out
4th row	Check-Out
5th row	Canceled

Value	Count	Frequency (%)
Check-Out	37738	63.2%
Canceled	21363	35.8%
No-Show	594	1.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
check-out	37738	63.2%
canceled	21363	35.8%
no-show	594	1.0%

Most occurring characters

Value	Count	Frequency (%)
e	80464	15.6%
C	59101	11.5%
c	59101	11.5%
h	38332	7.4%
-	38332	7.4%
k	37738	7.3%
O	37738	7.3%
u	37738	7.3%
t	37738	7.3%
a	21363	4.2%
Other values (7)	67059	13.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	378345	73.5%
Uppercase Letter	98027	19.0%
Dash Punctuation	38332	7.4%

Most frequent character per category

Value	Count	Frequency (%)
e	80464	21.3%
c	59101	15.6%
h	38332	10.1%
k	37738	10.0%
u	37738	10.0%
t	37738	10.0%
a	21363	5.6%
n	21363	5.6%
l	21363	5.6%
d	21363	5.6%
Other values (2)	1782	0.5%

Value	Count	Frequency (%)
C	59101	60.3%
O	37738	38.5%
N	594	0.6%
S	594	0.6%

Value	Count	Frequency (%)
-	38332	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	476372	92.6%
Common	38332	7.4%

Most frequent character per script

Value	Count	Frequency (%)
e	80464	16.9%
C	59101	12.4%
c	59101	12.4%
h	38332	8.0%
k	37738	7.9%
O	37738	7.9%
u	37738	7.9%
t	37738	7.9%
a	21363	4.5%
n	21363	4.5%
Other values (6)	45696	9.6%

Value	Count	Frequency (%)
-	38332	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	514704	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	80464	15.6%
C	59101	11.5%
c	59101	11.5%
h	38332	7.4%
-	38332	7.4%
k	37738	7.3%
O	37738	7.3%
u	37738	7.3%
t	37738	7.3%
a	21363	4.2%
Other values (7)	67059	13.0%

ReservationStatusDate
Categorical

HIGH CARDINALITY

Distinct	902
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

2015-10-21	730
2015-07-06	392
2016-11-25	387
2015-01-01	384
2016-01-18	318
Other values (897)	57484

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	596950
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	27 ?
Unique (%)	< 0.1%

Sample

1st row	2015-07-17
2nd row	2017-01-06
3rd row	2016-02-16
4th row	2016-10-11
5th row	2016-02-20

Value	Count	Frequency (%)
2015-10-21	730	1.2%
2015-07-06	392	0.7%
2016-11-25	387	0.6%
2015-01-01	384	0.6%
2016-01-18	318	0.5%
2015-07-02	231	0.4%
2016-12-07	221	0.4%
2015-12-18	214	0.4%
2016-02-09	190	0.3%
2016-04-04	189	0.3%
Other values (892)	56439	94.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
2015-10-21	730	1.2%
2015-07-06	392	0.7%
2016-11-25	387	0.6%
2015-01-01	384	0.6%
2016-01-18	318	0.5%
2015-07-02	231	0.4%
2016-12-07	221	0.4%
2015-12-18	214	0.4%
2016-02-09	190	0.3%
2016-04-04	189	0.3%
Other values (892)	56439	94.5%

Most occurring characters

Value	Count	Frequency (%)
0	135108	22.6%
-	119390	20.0%
1	109340	18.3%
2	93814	15.7%
6	39657	6.6%
7	29956	5.0%
5	23436	3.9%
3	13436	2.3%
8	11483	1.9%
9	10783	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	477560	80.0%
Dash Punctuation	119390	20.0%

Most frequent character per category

Value	Count	Frequency (%)
0	135108	28.3%
1	109340	22.9%
2	93814	19.6%
6	39657	8.3%
7	29956	6.3%
5	23436	4.9%
3	13436	2.8%
8	11483	2.4%
9	10783	2.3%
4	10547	2.2%

Value	Count	Frequency (%)
-	119390	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	596950	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	135108	22.6%
-	119390	20.0%
1	109340	18.3%
2	93814	15.7%
6	39657	6.6%
7	29956	5.0%
5	23436	3.9%
3	13436	2.3%
8	11483	1.9%
9	10783	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	596950	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	135108	22.6%
-	119390	20.0%
1	109340	18.3%
2	93814	15.7%
6	39657	6.6%
7	29956	5.0%
5	23436	3.9%
3	13436	2.3%
8	11483	1.9%
9	10783	1.8%

Hotel
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	466.5 KiB

City Hotel	39681
Resort Hotel	20014

Length

Max length	12
Median length	10
Mean length	10.67054192
Min length	10

Characters and Unicode

Total characters	636978
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Resort Hotel
2nd row	Resort Hotel
3rd row	Resort Hotel
4th row	Resort Hotel
5th row	City Hotel

Value	Count	Frequency (%)
City Hotel	39681	66.5%
Resort Hotel	20014	33.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
hotel	59695	50.0%
city	39681	33.2%
resort	20014	16.8%

Most occurring characters

Value	Count	Frequency (%)
t	119390	18.7%
e	79709	12.5%
o	79709	12.5%
	59695	9.4%
H	59695	9.4%
l	59695	9.4%
C	39681	6.2%
i	39681	6.2%
y	39681	6.2%
R	20014	3.1%
Other values (2)	40028	6.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	457893	71.9%
Uppercase Letter	119390	18.7%
Space Separator	59695	9.4%

Most frequent character per category

Value	Count	Frequency (%)
t	119390	26.1%
e	79709	17.4%
o	79709	17.4%
l	59695	13.0%
i	39681	8.7%
y	39681	8.7%
s	20014	4.4%
r	20014	4.4%

Value	Count	Frequency (%)
H	59695	50.0%
C	39681	33.2%
R	20014	16.8%

Value	Count	Frequency (%)
	59695	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	577283	90.6%
Common	59695	9.4%

Most frequent character per script

Value	Count	Frequency (%)
t	119390	20.7%
e	79709	13.8%
o	79709	13.8%
H	59695	10.3%
l	59695	10.3%
C	39681	6.9%
i	39681	6.9%
y	39681	6.9%
R	20014	3.5%
s	20014	3.5%

Value	Count	Frequency (%)
	59695	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	636978	100.0%

Most frequent character per block

Value	Count	Frequency (%)
t	119390	18.7%
e	79709	12.5%
o	79709	12.5%
	59695	9.4%
H	59695	9.4%
l	59695	9.4%
C	39681	6.2%
i	39681	6.2%
y	39681	6.2%
R	20014	3.1%
Other values (2)	40028	6.3%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	IsCanceled	LeadTime	ArrivalDateYear	ArrivalDateMonth	ArrivalDateWeekNumber	ArrivalDateDayOfMonth	StaysInWeekendNights	StaysInWeekNights	Adults	Children	Meal	Country	MarketSegment	DistributionChannel	IsRepeatedGuest	PreviousCancellations	ReservedRoomType	AssignedRoomType	DepositType	Agent	Company	DaysInWaitingList	CustomerType	ADR	RequiredCarParkingSpaces	TotalOfSpecialRequests	ReservationStatus	ReservationStatusDate	Hotel
0	429	0	57	2015	July	29	15	0	2	2	0.0	FB	PRT	Groups	Direct	0	0	A	A	No Deposit	305	NULL	0	Transient-Party	107.00	0	0	Check-Out	2015-07-17	Resort Hotel
1	11165	1	203	2017	April	17	25	0	2	2	0.0	HB	PRT	Groups	TA/TO	0	0	A	A	No Deposit	NULL	NULL	0	Transient-Party	90.00	0	0	Canceled	2017-01-06	Resort Hotel
2	21043	0	83	2016	February	7	9	2	5	2	0.0	BB	GBR	Offline TA/TO	TA/TO	0	0	A	D	No Deposit	6	NULL	0	Transient	26.00	0	0	Check-Out	2016-02-16	Resort Hotel
3	22591	0	0	2016	October	42	10	1	0	1	0.0	BB	PRT	Online TA	TA/TO	1	0	A	A	No Deposit	240	NULL	0	Transient-Party	56.00	0	1	Check-Out	2016-10-11	Resort Hotel
4	54136	1	187	2016	July	28	7	0	2	0	2.0	BB	GBR	Online TA	TA/TO	0	0	B	B	No Deposit	9	NULL	0	Transient-Party	86.50	0	0	Canceled	2016-02-20	City Hotel
5	61873	1	41	2016	December	53	27	2	5	2	0.0	BB	PRT	Groups	TA/TO	0	0	A	A	No Deposit	NULL	NULL	0	Transient-Party	69.29	0	0	Canceled	2016-12-12	City Hotel
6	73719	1	258	2015	July	27	2	0	2	2	0.0	BB	PRT	Groups	TA/TO	1	1	A	A	No Deposit	1	NULL	0	Transient-Party	62.80	0	0	Canceled	2014-10-17	City Hotel
7	48420	1	31	2016	March	13	23	0	1	2	0.0	BB	ESP	Online TA	TA/TO	0	0	A	A	No Deposit	9	NULL	0	Transient	126.90	0	0	Canceled	2016-03-18	City Hotel
8	84433	0	22	2016	February	8	19	2	5	2	0.0	BB	GBR	Direct	Direct	0	0	A	A	No Deposit	NULL	NULL	0	Transient	100.00	1	1	Check-Out	2016-02-26	City Hotel
9	51422	1	322	2016	May	21	19	1	3	2	0.0	BB	PRT	Offline TA/TO	TA/TO	0	0	A	A	Non Refund	31	NULL	120	Transient	80.00	0	0	Canceled	2016-02-10	City Hotel

Last rows

	df_index	IsCanceled	LeadTime	ArrivalDateYear	ArrivalDateMonth	ArrivalDateWeekNumber	ArrivalDateDayOfMonth	StaysInWeekendNights	StaysInWeekNights	Adults	Children	Meal	Country	MarketSegment	DistributionChannel	ReservedRoomType	AssignedRoomType	BookingChanges	DepositType	Agent	Company	DaysInWaitingList	CustomerType	ADR	TotalOfSpecialRequests	ReservationStatus	ReservationStatusDate	Hotel
59685	78848	0	29	2015	October	42	14	0	4	2	2.0	BB	FIN	Online TA	TA/TO	F	F	0	No Deposit	9	NULL	0	Contract	163.58	1	Check-Out	2015-10-18	City Hotel
59686	8369	1	2	2016	September	39	24	2	1	2	2.0	BB	BEL	Online TA	TA/TO	G	G	0	No Deposit	240	NULL	0	Transient	165.00	0	Canceled	2016-09-23	Resort Hotel
59687	1182	0	96	2015	August	34	17	1	5	2	0.0	BB	PRT	Online TA	TA/TO	A	A	0	No Deposit	240	NULL	0	Transient-Party	134.00	3	Check-Out	2015-08-23	Resort Hotel
59688	91307	0	45	2016	June	25	17	1	2	2	0.0	BB	PRT	Groups	TA/TO	A	A	0	No Deposit	1	NULL	0	Transient-Party	65.00	1	Check-Out	2016-06-20	City Hotel
59689	110522	0	123	2017	April	17	24	1	3	2	0.0	BB	FRA	Direct	Direct	A	A	0	No Deposit	14	NULL	0	Transient	105.75	1	Check-Out	2017-04-28	City Hotel
59690	42302	0	41	2015	September	36	4	0	1	2	0.0	HB	ITA	Offline TA/TO	TA/TO	A	A	0	No Deposit	39	NULL	38	Transient-Party	110.00	0	Check-Out	2015-09-05	City Hotel
59691	4829	0	171	2016	April	15	4	1	1	1	0.0	HB	DEU	Groups	TA/TO	A	A	1	Non Refund	298	NULL	0	Transient-Party	54.50	0	Check-Out	2016-04-06	Resort Hotel
59692	54784	1	177	2016	July	31	26	0	4	2	0.0	SC	ROU	Online TA	TA/TO	A	A	0	No Deposit	9	NULL	0	Transient	80.75	1	Canceled	2016-03-05	City Hotel
59693	110326	0	31	2017	April	16	21	2	3	2	0.0	BB	DEU	Offline TA/TO	TA/TO	A	A	0	No Deposit	21	NULL	0	Transient-Party	85.00	0	Check-Out	2017-04-26	City Hotel
59694	30708	0	0	2016	December	49	1	0	1	2	0.0	BB	PRT	Direct	Direct	A	A	1	No Deposit	NULL	NULL	0	Transient	43.00	0	Check-Out	2016-12-02	Resort Hotel

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters